Creating Drill Through Information Buttons 24
Next, we will set up the drill through information buttons.
Step 1: Create a Drill Through Information Button on Dashboard 01
In Power BI Desktop, click on the page, RaleighPoliceIncidents
Click Insert tab -> Buttons and select Information
Visualizations
Click the Information icon
Fields
N/A
Visualizations
Under Visualizations -> Button Text -> Set it to OFF
Under Visualizations -> Icon -> Set it to ON = Default State , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt
Under Visualizations -> Background -> Set it to ON , Color = FFF
Under Visualizations -> Border -> Set it to ON , Color = 666666
Under Visualizations -> Action -> Type = Drill Through , Destination = RaleighPoliceIncidents-DistrictStep 2: Create a Drill Through Information Button on Dashboard 02
Click on the 'Drill Through 1 of 3' from Dashboard 01 , press Ctrl+C to copy and Ctrl+V to paste it the 2nd Dashboard page, RaleighPoliceIncidents-District
From the copied 'Drill Through 1 of 3' from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Under Visualizations -> General: X Position = 1195 , Y Position = 0 , Width = 205 , Height = 108Under Visualizations -> Button Text -> Set it to OFF
Under
Visualizations -> Icon -> Set it to ON = Default State ,
Information , Padding = 4 , Vertical Alignment = Center , Horizontal
Alignment = Center , Line Color = 000000 , Weight = 5 pt
Under Visualizations -> Background -> Set it to ON , Color = FFF
Under Visualizations -> Border -> Set it to ON , Color = 666666
Under Visualizations -> Action -> Type = Drill Through , Destination = RaleighPoliceIncidents-StreetStep 3: Create a Drill Through Information Button on Dashboard 03
Click on the 'Drill Through 1 of 3' from Dashboard 01 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, RaleighPoliceIncidents-District
From the copied 'Drill Through 1 of 3' from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Under Visualizations -> General: X Position = 1195 , Y Position = 0 , Width = 205 , Height = 120Under Visualizations -> Button Text -> Set it to OFF
Under
Visualizations -> Icon -> Set it to ON = Default State ,
Information , Padding = 4 , Vertical Alignment = Center , Horizontal
Alignment = Center , Line Color = 000000 , Weight = 5 pt
Under Visualizations -> Background -> Set it to ON , Color = FFF
Under Visualizations -> Border -> Set it to ON , Color = 666666
Under Visualizations -> Action -> Set it to OFFWhen finished, save project.